package com.yangjun.entity.report;

import lombok.*;

@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class DwSingleProductEntity {
	
	private String dataDate;//日期
	private String year;//年
	private String month;//月
	private String week;//周
	
	private String warecode;//商品编码
	private String warename;//商品名称
	private String sourcename;//平台名称
	private String shopname;//店铺
	private String facategory;//财务科室
	private String department;//科室
	private String tmDepartment;//天猫科室
	private String waregeneralname;//商品通用名
	private String brandname;//品牌名称
	private String model;//规格
	private String manufacturername;//生产厂家
	private Integer salesQty;//总销量
	private Integer netSalesQty;//主品销量
	private Integer salesGiftQty;//赠品销量
	private Float netSalesAmount;//主品销额
	private Integer orderCnt;//订单数-出库
	private Float avgSalesAmount;//销售均价
	private Float marketingcost;//搭配成本
	private Float salesCost;//采购成本
	private Float othercost;//其他成本
	private Float grossProfit;//毛利额
	private Float grossProfitRate;//毛利率
	private Float netGrossProfit;//净利额
	private Float netGrossProfitRate;//净利率
	private Integer returnQty;//退货数量
	private Float returnAmt;//退货金额
	private Float returnRate;//退货率
	private Integer allPurchaseNum;//会员数
	private Integer oldPurchaseNum;//平台老会员数
	private Float oldPurchaseRate;//平台老会员占比
	private Integer oldPurorderNum;//平台老会员订单数
	private Float oldPurchaseAmt;//平台老会员金额
	private Integer newPurchaseNum;//商品新会员数
	private Float newPurchaseRate;//商品新会员占比
	private Integer newPurorderNum;//商品新会员订单数
	private Float newPurchaseAmt;//商品新会员金额
	private Integer twoPurchNum;//商品复购人数
	private Float twoPurchRate;//商品复购率
	private Float twoPurchAmt;//商品复购金额
	
	private Integer preorder; //预订单数
	private Integer onlineconsult; //有效咨询数
	
	private Integer visitors;//访客数
	private Integer pv;//浏览量
	private Integer avgVisitTime;//平均停留时长
	private Float jumpRate;//跳出率
	private Float exitRate;//退出率
	private Integer flowOrderCnt;//订单数-下单
	private Integer qty;//下单销量
	private Integer mainQty;//主品销量
	private Float orderAmount;//下单金额
	private Float orderRate;//下单转化率
	private Integer orderVisitors;//下单访客数
	private Integer countNum;
	
	//新增自建会员指标
	private Integer selfAllPurchaseNum;//会员数-自建
	private Integer selfAllPurorderNum;//会员订单数-自建
	private Float selfAllPurchaseAmt;//会员金额-自建
	private Integer selfOldPurchaseNum;//老会员数-自建
	private Float selfOldPurchaseRate;//老会员占比-自建
	private Integer selfOldPurorderNum;//老会员订单数-自建
	private Float selfOldPurchaseAmt;//老会员金额-自建
	private Integer selfNewPurchaseNum;//新会员数-自建
	private Float selfNewPurchaseRate;//新会员占比-自建
	private Integer selfNewPurorderNum;//新会员订单数-自建
	private Float selfNewPurchaseAmt;//新会员金额-自建
	private Integer selfTwoPurchNum;//复购人数-自建
	private Float selfTwoPurchRate;//复购率-自建
	private Float selfTwoPurchAmt;//复购金额-自建
	
	
	
}
